clear all
*Set Directory 
cd "~/Box Sync/Replication_AJPS_0215"
eststo clear
set more off
set mem 900m

clear all
use "Final_Analysis_Data.dta"
xtset Dist_IRN election_id

tab Pass if AYP_Not_Met_2 == 0
tab Pass if AYP_Not_Met_2 == 1


*Table 1 Replication
eststo: xi: reg Pass AYP_Not_Met_2 i.FY, vce(cluster Dist_IRN)
estadd local Dist_FE "No"
estadd local Year_FE "Yes"
estadd local Ac_Desig "No"

*OLS District Covariates
eststo:  xi: reg Pass AYP_Not_Met_2 i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2, vce(cluster Dist_IRN)
estadd local Dist_FE "No"
estadd local Year_FE "Yes"
estadd local Ac_Desig "No"

*OLS District Covariates with Mills, Private School, Own Housing (No Percentage Improvement)
eststo: xi: reg Pass AYP_Not_Met_2 i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills household_privateenrollment_perc housing_own_percent, vce(cluster Dist_IRN)
estadd local Dist_FE "No"
estadd local Year_FE "Yes"
estadd local Ac_Desig "No"

*OLS District Covariates with Mills, Private School, Own Housing, Designation (No Percentage Improvement)
eststo: xi: reg Pass AYP_Not_Met_2 i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills household_privateenrollment_perc housing_own_percent i.Designation, vce(cluster Dist_IRN)
estadd local Dist_FE "No"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"


*District Fixed Effects
eststo: xi: xtreg Pass AYP_Not_Met_2 i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills i.Designation, fe vce(cluster Dist_IRN)

estadd local Dist_FE "Yes"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"

*esttab using Table_1.tex, note("Heteroskedasticity robust standard errors clustered at the district level in parentheses") label se star(* 0.05 ** 0.01 *** 0.001) r2 scalars("Year_FE Year Fixed Effects" "Dist_FE District Fixed Effects" "Ac_Desig Academic Designations")  title(Linear Probability Models for Levy Passage\label{tab1}) drop( _IFY_2004 _IFY_2005 _IFY_2006 _IFY_2007 _IFY_2008 _IFY_2009 _IFY_2010 _IFY_2011 _IFY_2012 _IDesignati_2 _IDesignati_3 _IDesignati_4 _IDesignati_5 _IDesignati_6) replace


merge m:1 Dist_IRN FY using "TtlDistrictVA_FY07toFY12.dta"


*Table A6 Replication

label variable Gain "Gain Score"
tab FY, gen(Year_FE_)
eststo: xi: reg Pass AYP_Not_Met_2 Gain i.FY, vce(cluster Dist_IRN)
estadd local Dist_FE "No"
estadd local Year_FE "Yes"
estadd local Ac_Desig "No"

*OLS District Covariates
eststo:  xi: reg Pass AYP_Not_Met_2 i.FY Gain Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2, vce(cluster Dist_IRN)
estadd local Dist_FE "No"
estadd local Year_FE "Yes"
estadd local Ac_Desig "No"

*OLS District Covariates with Mills, Private School, Own Housing (No Percentage Improvement)
eststo: xi: reg Pass AYP_Not_Met_2 i.FY Gain Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills household_privateenrollment_perc housing_own_percent, vce(cluster Dist_IRN)
estadd local Dist_FE "No"
estadd local Year_FE "Yes"
estadd local Ac_Desig "No"

*OLS District Covariates with Mills, Private School, Own Housing, Designation (No Percentage Improvement)
eststo: xi: reg Pass AYP_Not_Met_2 Gain i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills household_privateenrollment_perc housing_own_percent i.Designation, vce(cluster Dist_IRN)
estadd local Dist_FE "No"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"

*District Fixed Effects

eststo: xi: xtreg Pass AYP_Not_Met_2 Gain i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills i.Designation, fe vce(cluster Dist_IRN)


estadd local Dist_FE "Yes"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"

*esttab using Table_A6.tex, note("Heteroskedasticity robust standard errors clustered at the district level in parentheses")  label se star(* 0.05 ** 0.01 *** 0.001) r2 scalars("Year_FE Year Fixed Effects" "Dist_FE District Fixed Effects" "Ac_Desig Academic Designations")  title(Linear Probability Models for Levy Passage) drop(_IFY_2004 _IFY_2005 _IFY_2006  _IFY_2007 _IFY_2008 _IFY_2009 _IFY_2010 _IFY_2011 _IFY_2012 _IDesignati_2 _IDesignati_3 _IDesignati_4 _IDesignati_5 _IDesignati_6 _cons) replace
eststo clear


label variable Last_Year_Fail "Lagged AYP Failure"

*Table 2 Replication
eststo: xi: reg Pass Last_Year_Fail  i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills household_privateenrollment_perc housing_own_percent i.Designation, vce(cluster Dist_IRN)
estadd local Dist_FE "No"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"

eststo: xi: xtreg Pass Last_Year_Fail i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills i.Designation, fe vce(cluster Dist_IRN)
estadd local Dist_FE "Yes"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"

eststo: xi: reg Pass Last_Year_Fail AYP_Not_Met_2  i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills household_privateenrollment_perc housing_own_percent i.Designation, vce(cluster Dist_IRN)
estadd local Dist_FE "No"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"

eststo: xi: xtreg Pass Last_Year_Fail AYP_Not_Met_2  i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills i.Designation, fe vce(cluster Dist_IRN)
estadd local Dist_FE "Yes"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"
*esttab using Table_2.tex, note("Heteroskedasticity robust standard errors clustered at the district level in parentheses") label se star(* 0.05 ** 0.01 *** 0.001) r2 scalars("Year_FE Year Fixed Effects" "Dist_FE District Fixed Effects" "Ac_Desig Academic Designations")  order(Last_Year_Fail AYP_Not_Met_2) title(Lagged AYP Status) drop(_IFY_2004 _IFY_2005 _IFY_2006 _IFY_2007 _IFY_2008 _IFY_2009 _IFY_2010 _IFY_2011 _IFY_2012 _IDesignati_2 _IDesignati_3 _IDesignati_4 _IDesignati_5 _IDesignati_6) replace

eststo clear



label variable First_Fail "First AYP Failure"
label variable AYP_Not_Met_Not_First "Subsequent AYP Failure"


*Table 4 Replication
eststo:  xi: reg Pass First_Fail i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills household_privateenrollment_perc housing_own_percent i.Designation, vce(cluster Dist_IRN)
estadd local Dist_FE "No"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"

eststo: xi: xtreg Pass First_Fail i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills i.Designation, fe vce(cluster Dist_IRN)
estadd local Dist_FE "Yes"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"


eststo: xi: reg Pass First_Fail AYP_Not_Met_Not_First i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills household_privateenrollment_perc housing_own_percent i.Designation, vce(cluster Dist_IRN)
estadd local Dist_FE "No"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"

eststo: xi: xtreg Pass First_Fail AYP_Not_Met_Not_First i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills i.Designation, fe vce(cluster Dist_IRN)
estadd local Dist_FE "Yes"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"

*esttab using Table_4.tex, note("Heteroskedasticity robust standard errors clustered at the district level in parentheses") label se star(* 0.05 ** 0.01 *** 0.001) order(First_Fail AYP_Not_Met_Not_First) r2 scalars("Year_FE Year Fixed Effects" "Dist_FE District Fixed Effects" "Ac_Desig Academic Designations")  title(First AYP Failure) drop( _IFY_2004 _IFY_2005 _IFY_2006 _IFY_2007 _IFY_2008 _IFY_2009 _IFY_2010 _IFY_2011 _IFY_2012 _IDesignati_2 _IDesignati_3 _IDesignati_4 _IDesignati_5 _IDesignati_6) replace

eststo clear

tab FY, gen(Year_FE)

*Table 3 Replication
*Broken Out By Month 
*August and Earlier
eststo: xi: reg Pass AYP_Not_Met_2 Year_FE2-Year_FE8 Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills household_privateenrollment_perc housing_own_percent i.Designation if Month<=8, vce(cluster Dist_IRN)
estadd local Dist_FE "No"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"

*Later than August
eststo: xi: reg Pass AYP_Not_Met_2 Year_FE1-Year_FE8 Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills household_privateenrollment_perc housing_own_percent i.Designation if Month>8, vce(cluster Dist_IRN)
estadd local Dist_FE "No"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"


*Interactions By Month
gen Early_Month =  Month <= 8
gen AYP_Not_Met_Early = AYP_Not_Met_2*Early_Month

label variable Early_Month "Pre-November Election"
label variable AYP_Not_Met_Early "Pre-November Election*AYP Failure"

eststo: xi: reg Pass AYP_Not_Met_Early AYP_Not_Met_2 Early_Month Year_FE1-Year_FE8 Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills household_privateenrollment_perc housing_own_percent i.Designation, vce(cluster Dist_IRN)

estadd scalar F_diff = r(F)

estadd scalar p_diff = r(P)
estadd local Dist_FE "No"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"

eststo: xi: xtreg Pass AYP_Not_Met_Early AYP_Not_Met_2 Early_Month Year_FE1-Year_FE8 Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills i.Designation, fe vce(cluster Dist_IRN)

estadd scalar F_diff = r(F)
estadd scalar p_diff = r(P)

estadd local Dist_FE "Yes"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"

*esttab using Table_3.tex, note("Heteroskedasticity robust standard errors clustered at the district level in parentheses") label mtitles("Pre-November Elections" "November Elections" "Full" "Full") order(AYP_Not_Met_2 AYP_Not_Met_Early Early_Month) se star(* 0.05 ** 0.01 *** 0.001) r2  scalars( "Year_FE Year Fixed Effects" "Dist_FE District Fixed Effects" "Ac_Desig Academic Designations")  title(November vs. Earlier Elections) keep( _cons  AYP_Not_Met_Early Early_Month household_privateenrollment_perc housing_own_percent AYP_Not_Met_2 Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills) replace
eststo clear

*Table 5 Replication
*Placebo Tests

label variable Future_Fail "Forward Failure"

eststo: xi: xtreg Pass Future_Fail i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills i.Designation, fe vce(cluster Dist_IRN)
estadd local Dist_FE "Yes"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"


eststo: xi: xtreg Pass Future_Fail AYP_Not_Met_2 i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills i.Designation, fe vce(cluster Dist_IRN)
estadd local Dist_FE "Yes"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"

*esttab using Table_5.tex, note("Heteroskedasticity robust standard errors clustered at the district level in parentheses") label se star(* 0.05 ** 0.01 *** 0.001) r2  order(Future_Fail AYP_Not_Met_2) scalars("Year_FE Year Fixed Effects" "Dist_FE District Fixed Effects" "Ac_Desig Academic Designations")  title(Placebo Tests for Levy Passage) drop(_IFY_2004 _IFY_2005 _IFY_2006 _IFY_2007 _IFY_2008 _IFY_2009 _IFY_2010 _IFY_2011 _IFY_2012 _IDesignati_2 _IDesignati_3 _IDesignati_4 _IDesignati_5 _IDesignati_6) replace
eststo clear


*Table A2 Replication
*Probit Year FE
eststo:  xi: probit Pass AYP_Not_Met_2 i.FY, vce(cluster Dist_IRN)
estadd local Dist_FE "No"
estadd local Year_FE "Yes"
estadd local Ac_Desig "No"

* Probit District Covariates
eststo:  xi: probit Pass AYP_Not_Met_2 i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2, vce(cluster Dist_IRN)
estadd local Dist_FE "No"
estadd local Year_FE "Yes"
estadd local Ac_Desig "No"


* Probit District Covariates with Mills, Private School, Own Housing (No Percentage Improvement)
eststo: xi: probit Pass AYP_Not_Met_2 i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills household_privateenrollment_perc housing_own_percent, vce(cluster Dist_IRN)
estadd local Dist_FE "No"
estadd local Year_FE "Yes"
estadd local Ac_Desig "No"

* Probit District Covariates with Mills, Private School, Own Housing, Designation (No Percentage Improvement)
eststo: xi: probit Pass AYP_Not_Met_2 i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills household_privateenrollment_perc housing_own_percent i.Designation, vce(cluster Dist_IRN)
estadd local Dist_FE "No"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"


*District Fixed Effects 

*Differencing Over All Observed Levies Within District
set matsize 800
eststo: xi: probit Pass AYP_Not_Met_2 i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills i.Designation i.Dist_IRN, vce(cluster Dist_IRN)
estadd local Dist_FE "Yes"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"


*esttab using Table_A2.tex, note("Heteroskedasticity robust standard errors clustered at the district level in parentheses") label se star(* 0.05 ** 0.01 *** 0.001) r2 scalars("Year_FE Year Fixed Effects" "Dist_FE District Fixed Effects" "Ac_Desig Academic Designations")  title(Probit Models for Levy Passage) keep( _cons household_privateenrollment_perc housing_own_percent AYP_Not_Met_2 Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills) replace

eststo clear



*Feb_March Dummy 
gen Feb_March = 0
replace Feb_March = 1 if Month == 2 | Month == 3
*May Dummy
gen May = 0
replace May = 1 if Month == 5 

*August Dummy
gen August = 0
replace August = 1 if Month == 8

gen AYP_Not_Met_2_Feb_March = AYP_Not_Met_2*Feb_March
gen AYP_Not_Met_2_May = AYP_Not_Met_2*May
gen AYP_Not_Met_2_August = AYP_Not_Met_2*August



*Table A3 Replication
gen Months_Since_Info = .
replace Months_Since_Info = 2 if Month == 11
replace Months_Since_Info = 5 if Month == 2
replace Months_Since_Info = 6 if Month == 3
replace Months_Since_Info = 8 if Month == 5
replace Months_Since_Info = 11 if Month == 8


gen Month_AYP_Inter = Months_Since_Info*AYP_Not_Met_2

label variable Months_Since_Info "Months Since AYP Release"
label variable Month_AYP_Inter "Months Since AYP Release*AYP Failure"

eststo: xi: reg Pass AYP_Not_Met_2 Months_Since_Info Month_AYP_Inter i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills household_privateenrollment_perc housing_own_percent i.Designation, vce(cluster Dist_IRN)
estadd local Dist_FE "No"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"

 
eststo: xi: xtreg Pass AYP_Not_Met_2 Months_Since_Info Month_AYP_Inter i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills i.Designation, fe vce(cluster Dist_IRN)

estadd local Dist_FE "Yes"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"


lincom  Month_AYP_Inter*2 +  AYP_Not_Met_2
lincom  Month_AYP_Inter*5 +  AYP_Not_Met_2
lincom  Month_AYP_Inter*6 +  AYP_Not_Met_2
lincom  Month_AYP_Inter*8 +  AYP_Not_Met_2
lincom  Month_AYP_Inter*11 +  AYP_Not_Met_2

lincom Month_AYP_Inter*11 - Month_AYP_Inter*2


label variable AYP_Not_Met_2_Feb_March "AYP Not Met*Winter Election"
label variable AYP_Not_Met_2_May "AYP Not Met*Spring Election"
label variable AYP_Not_Met_2_August "AYP Not Met*Summer Election"

eststo: xi: reg Pass AYP_Not_Met_2 AYP_Not_Met_2_Feb_March AYP_Not_Met_2_May AYP_Not_Met_2_August May Feb_March August i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills i.Designation,  vce(cluster Dist_IRN)
estadd local Dist_FE "No"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"

eststo: xi: xtreg Pass AYP_Not_Met_2 AYP_Not_Met_2_Feb_March AYP_Not_Met_2_May AYP_Not_Met_2_August May Feb_March August i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills i.Designation, fe vce(cluster Dist_IRN)
estadd local Dist_FE "Yes"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"

*esttab using Table_A3.tex, note("Heteroskedasticity robust standard errors clustered at the district level in parentheses") label se star(* 0.05 ** 0.01 *** 0.001) r2 scalars("Year_FE Year Fixed Effects" "Dist_FE District Fixed Effects" "Ac_Desig Academic Designations")  title(Informational Decay Models) drop(_IFY_2004 _IFY_2005 _IFY_2006 _IFY_2007 _IFY_2008 _IFY_2009 _IFY_2010 _IFY_2011 _IFY_2012 _IDesignati_2 _IDesignati_3 _IDesignati_4 _IDesignati_5 _IDesignati_6 May Feb_March August) replace

eststo clear


*Table A5 Replication
*OLS District Covariates 
eststo:  xi: reg Mills AYP_Not_Met_2 i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2, vce(cluster Dist_IRN)
estadd local Dist_FE "No"
estadd local Year_FE "Yes"
estadd local Ac_Desig "No"

*OLS District Covariates with Mills, Private School, Own Housing (No Percentage Improvement)
eststo: xi: reg Mills AYP_Not_Met_2 i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 household_privateenrollment_perc housing_own_percent, vce(cluster Dist_IRN)
estadd local Dist_FE "No"
estadd local Year_FE "Yes"
estadd local Ac_Desig "No"

*OLS District Covariates with Mills, Private School, Own Housing, Designation (No Percentage Improvement)
eststo: xi: reg Mills AYP_Not_Met_2 i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 household_privateenrollment_perc housing_own_percent i.Designation, vce(cluster Dist_IRN)
estadd local Dist_FE "No"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"

*District Fixed Effects

eststo: xi: xtreg Mills AYP_Not_Met_2 i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 i.Designation, fe vce(cluster Dist_IRN)
estadd local Dist_FE "Yes"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"


*esttab using Table_A5.tex, note("Heteroskedasticity robust standard errors clustered at the district level in parentheses") label se star(* 0.05 ** 0.01 *** 0.001) r2 scalars("Year_FE Year Fixed Effects" "Dist_FE District Fixed Effects" "Ac_Desig Academic Designations")  title(Mills as Dependent Variable) drop(_IFY_2004 _IFY_2005 _IFY_2006 _IFY_2007 _IFY_2008 _IFY_2009 _IFY_2010 _IFY_2011 _IFY_2012 _IDesignati_2 _IDesignati_3 _IDesignati_4 _IDesignati_5 _IDesignati_6) replace
eststo clear



* Conditional Logit Analysis

*Table A7 Replication
eststo: xi: clogit Pass AYP_Not_Met_2 i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills i.Designation, group(Dist_IRN) vce(cluster Dist_IRN)

estadd local Dist_FE "Yes"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"

eststo: xi: clogit Pass AYP_Not_Met_2 Gain i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills, group(Dist_IRN) vce(cluster Dist_IRN)

estadd local Dist_FE "Yes"
estadd local Year_FE "Yes"
estadd local Ac_Desig "No"

eststo: xi: clogit Pass Last_Year_Fail i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills i.Designation, group(Dist_IRN) vce(cluster Dist_IRN)
estadd local Dist_FE "Yes"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"

eststo: xi: clogit Pass Last_Year_Fail AYP_Not_Met_2  i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills i.Designation, group(Dist_IRN) vce(cluster Dist_IRN)
estadd local Dist_FE "Yes"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"

*esttab using Table_A7.tex, order(AYP_Not_Met_2 Last_Year_Fail) pr2 note("Heteroskedasticity robust standard errors clustered at the district level in parentheses")  label se star(* 0.05 ** 0.01 *** 0.001) r2 scalars("Year_FE Year Fixed Effects" "Dist_FE District Fixed Effects" "Ac_Desig Academic Designations")  title(Conditional Logit Models for Levy Passage) drop(_IFY_2004 _IFY_2005 _IFY_2006 _IFY_2007 _IFY_2008 _IFY_2009 _IFY_2010 _IFY_2011 _IFY_2012 _IDesignati_2 _IDesignati_3 _IDesignati_4 _IDesignati_5 _IDesignati_6) replace

eststo clear 

*Table A8 Replication

eststo: xi: clogit Pass First_Fail i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills i.Designation, group(Dist_IRN) vce(cluster Dist_IRN)
estadd local Dist_FE "Yes"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"

eststo: xi: clogit Pass First_Fail AYP_Not_Met_Not_First i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills i.Designation, group(Dist_IRN) vce(cluster Dist_IRN)
estadd local Dist_FE "Yes"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"

eststo: xi: clogit Pass AYP_Not_Met_Early AYP_Not_Met_2 Early_Month i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills i.Designation, group(Dist_IRN) vce(cluster Dist_IRN)
estadd local Dist_FE "Yes"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"

eststo: xi: clogit Pass AYP_Not_Met_2 AYP_Not_Met_2_Feb_March AYP_Not_Met_2_May AYP_Not_Met_2_August May Feb_March August i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills i.Designation, group(Dist_IRN) vce(cluster Dist_IRN)
estadd local Dist_FE "Yes"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"

*esttab using Table_A8.tex, order(AYP_Not_Met_2 Last_Year_Fail First_Fail) pr2 note("Heteroskedasticity robust standard errors clustered at the district level in parentheses")  label se star(* 0.05 ** 0.01 *** 0.001) r2 scalars("Year_FE Year Fixed Effects" "Dist_FE District Fixed Effects" "Ac_Desig Academic Designations")  title(Conditional Logit Models for Levy Passage) drop(_IFY_2004 _IFY_2005 _IFY_2006 _IFY_2007 _IFY_2008 _IFY_2009 _IFY_2010 _IFY_2011 _IFY_2012 _IDesignati_2 _IDesignati_3 _IDesignati_4 _IDesignati_5 _IDesignati_6) replace

eststo clear 

*Table A9 Replication
eststo: xi: clogit Pass Future_Fail i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills i.Designation, group(Dist_IRN) vce(cluster Dist_IRN)
estadd local Dist_FE "Yes"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"

eststo: xi: clogit Pass Future_Fail AYP_Not_Met_2 i.FY Millage_Real Per_Pupil_Value Total_Expend Instruction_Expend PctEnrollBlack  PctEnrollHisp LEP_PctEnroll EconDisad_PctEnroll Disabled_PctEnroll Ln_Enroll2 Mills i.Designation, group(Dist_IRN) vce(cluster Dist_IRN)
estadd local Dist_FE "Yes"
estadd local Year_FE "Yes"
estadd local Ac_Desig "Yes"

*esttab using Table_A9.tex, pr2 note("Heteroskedasticity robust standard errors clustered at the district level in parentheses") label se star(* 0.05 ** 0.01 *** 0.001) r2  order(Future_Fail AYP_Not_Met_2) scalars("Year_FE Year Fixed Effects" "Dist_FE District Fixed Effects" "Ac_Desig Academic Designations")  title(Conditional Logit Placebo Tests for Levy Passage) drop(_IFY_2004 _IFY_2005 _IFY_2006 _IFY_2007 _IFY_2008 _IFY_2009 _IFY_2010 _IFY_2011 _IFY_2012 _IDesignati_2 _IDesignati_3 _IDesignati_4 _IDesignati_5 _IDesignati_6) replace
